Table Structure Upgrader for Delphi 2.0
---------------------------------------

18 June 1997

This software is Version 1.1


----------------------------------------------------
Please Note:
Due to the number of CD's and Web sites that mirror
this product please ensure you are using the latest
version by visiting http://www.iinet.com.au/~brade
----------------------------------------------------
1. BACKGROUND

If you have ever wanted to change the structure of a paradox table 
remotely on a clients PC then this unit will help you. It will
change the clients table to match the structure of the table on
the development system when the Delphi EXE was compiled.

This unit will update a Paradox table to have the same structure
as the paradox table used to compile the EXE. It will add any
additional fields and change the length of string fields as
required. This version does not delete fields or add indexes.
Adding index will be added to the next version.

This version upgrades nearly all field types (except Graphic and OLE
which will be in the next version). It has problems with paradox time
fields wich usually get mixed up with timestamp fields but I'm working
on the problem. The next version is due in about 10 days.



2. FILES

    UPGRADESRC.DCU - Contains the ValidateTable Function (Delphi 3.0)
    UPGRADESRC.DCU - Contains the ValidateTable Function (Delphi 2.0 rename to .dcu before using)

No additional files are required.
	


3. INSTALLATION

This is not a component. Do not try and add it to your palette as
it will not install. To use the component add UPGRADESRC to your
uses statement.

4. REQUIREMENTS

Your must have a TTable defined and have used the fields editor
to add every field from the table. If a field is not defined
by the fields editor this unit will not know about it, and therefore
it will not be touched/checked/upgraded.

The table must be able to be exclusively locked, ie no-one else has it open.


5. USING

Assuming your table is called Table1 do the following.

table1.active := False;  // The table must not be in use.
ValidateTable(Table1);   // This may take some time for big tables.

Validate table will then add and change the fields on the Disk
table to match the structure of the TTable in the EXE.

Notes:
	No Fields are ever deleted.
	Required fields are added and set to the default for that field.
	If a field is changed then it is converted using the same rules as
	the database desktop supplied with Delphi.
	If the table cannot be exclusively locked then it is not changed.
	If no fields are added or changed the table is not modified.



6. FREE LUNCH

  This component is not free. Please send money to:
  If you are a Single Developer send $25 Australian / $20US
  If you are have more than 1 Developer send $75 Australian / $60US

Brad Evans
PO Box 144
Burswood 6100
Western AUSTRALIA

Online Registration URL : http://www.iinet.com.au/~brade


Once payment has been received you recieve the latest version with
source code.

Email: brade@iinet.com.au
URL  : http://www.iinet.com.au/~brade

Check my URL for more components and latest versions. Please email
me with bugs/suggestions or enhancements